package com.huangpuweb.api.model;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

public class SysShopRecruitStreetRowMapper implements RowMapper<SysShopRecruitStreet>{



	@Override
	public SysShopRecruitStreet mapRow(ResultSet rs, int rowNum) throws SQLException {
		SysShopRecruitStreet  lj= new SysShopRecruitStreet();
		lj.setId(rs.getInt("id"));
		lj.setRoad_name(rs.getString("road_name"));
		lj.setUnit_adress(rs.getString("unit_adress"));
		lj.setSerial_number(rs.getString("serial_number"));
		lj.setDetail(rs.getString("detail"));
		lj.setUnit_name(rs.getString("unit_name"));
		lj.setLegal_person(rs.getString("legal_person"));
		lj.setLegal_person_phone(rs.getString("legal_person_phone"));
		lj.setName(rs.getString("name"));
		lj.setPhone(rs.getString("phone"));
		lj.setDz_number(rs.getString("dz_number"));
		lj.setCategary(rs.getString("categary"));
		lj.setStatus(rs.getString("status"));
		lj.setDz_affiliation(rs.getString("dz_affiliation"));
		lj.setLng(rs.getString("lng"));
		lj.setLat(rs.getString("lat"));
		lj.setSpec(rs.getString("spec"));
		return lj;
	}

}
